SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501548 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501548 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700290,631456,281785,839307,52403,998677,574617,373119,797925,452302,725247,886119,494102,386066,65607,988630,599912,393096,766414,107111,990810,43047,451906,478251,391213,359998,263065,792136,493695,335063,884550,525163,952693,294854,142217,787766,705371,811381,488290,80188,840908,1012990,932284,365997,164804,391531,576388,777540,158805,913317,532040,835343,339667,552535,248594,215800,923582,185765,842634,126880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001107s ]