SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326781 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326781 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550017,11487,372516,400568,140856,1002838,338849,680744,272987,594416,79472,806021,121893,331318,443845,342091,1009710,605030,682676,64038,290853,644803,523973,384302,788228,593481,406411,828526,817541,930283,497228,69966,412755,389129,752072,460061,395713,830315,97519,924054,745807,85540,1018404,4263,199728,177091,217147,508680,430965,968391,161722,419133,346814,113235,480526,717885,941159,710705,682087,490778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001210s ]