SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405884 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405884 [ RunTime:0.003677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287104,39531,265050,311877,1036399,897730,987850,961837,678799,594923,517777,393072,650338,522174,561628,929081,103119,646926,928808,676198,707108,884376,262354,638284,46062,244304,134454,772042,728021,713902,830826,331344,887574,746280,298162,397533,758927,568092,180729,894122,836964,344244,298450,71959,1010507,895874,581320,830975,898056,960026,823733,23740,370069,900832,368549,248069,790394,582515,1032598,269331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]