SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412270 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412270 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524292,172413,540751,56160,290604,694221,1029914,735955,333154,258635,499305,307505,437298,1041974,958483,415302,453364,518545,351430,643902,965017,326008,685484,35590,224218,43072,122067,456688,379783,144132,86943,607602,994338,104904,214706,463979,631274,90887,3814,907372,341211,319668,306340,558884,339743,695151,640226,435916,290943,895419,162850,272157,614647,810057,1040168,421987,192512,330200,32849,600792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001503s ]