SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52571 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52571 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699257,283671,352968,118349,946479,239253,32069,16591,807603,492232,495174,208112,437896,390109,871484,840702,144628,782925,1012947,628521,199122,749285,1011027,675615,501771,729665,194500,177123,597574,418213,754720,627571,820628,154958,327679,891774,866731,701432,278529,242883,744294,295368,142906,199907,161029,590984,1048326,818939,337867,1032095,228083,291082,544555,905684,1047482,368128,115388,291909,760428,986920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]