SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402308 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402308 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54399,168833,190834,402921,553421,228601,952052,620172,503827,380030,301039,783488,171953,1020534,1047291,764799,542961,335815,709265,685158,494967,732342,319250,102284,391020,991265,72399,494404,858656,222719,142385,419470,840159,480747,587014,668400,816098,712347,16373,916755,733900,599379,559336,887790,14904,800425,145539,711450,884316,1017661,258714,806672,662784,520084,687705,1002736,550120,1038489,299868,537185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]