SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201068 LIMIT 1 [ RunTime:0.000942s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201068 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845518,960451,12889,864543,706876,428795,673829,430424,1020561,233973,724437,558880,720844,172804,94999,83327,76261,895550,88223,423966,912440,123097,966959,96533,1024813,140799,816050,922348,300352,382296,778340,781880,721701,673382,809186,534909,102617,1022008,5611,123631,474768,197034,570597,944269,98876,456177,521563,940326,629897,809352,599751,253859,19478,445714,862039,712208,373480,429964,954338,241652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]