SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518409 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518409 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760566,515581,670625,271538,199314,13476,681321,615832,606133,1023582,227373,1023824,668919,734532,129722,20121,631749,651348,751042,899788,111212,513949,795889,886031,531225,134706,883000,107668,562288,769172,929748,736512,749003,801848,263082,303061,479188,418796,502630,883509,471141,102784,467546,119411,914378,547441,653039,45350,754014,371010,380584,580729,907908,6993,897048,565661,294011,1007990,934554,311793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]