SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645681 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645681 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619161,361009,665126,170162,516730,398553,464926,987613,403445,185047,755411,808794,138241,436296,109873,770151,827869,448557,94009,361760,463970,911263,384852,1037032,782613,5470,955417,848106,489059,601179,147583,139518,662839,113996,539875,980159,536961,659989,174324,548161,363815,798398,253002,424659,428025,929610,169340,458955,508006,912149,748677,712644,301627,507499,800213,55609,666803,951537,828668,256403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]