SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016317 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016317 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044088,497759,261842,15879,53187,701198,74509,985260,208528,160070,116469,934998,588331,170304,105296,880048,689813,294303,675491,850293,540727,688716,658833,921796,146688,965835,976830,195418,57317,513562,769724,3413,1033250,878069,994211,885179,941052,528687,96870,261211,571990,93792,236303,416705,497916,293044,554654,885493,290899,556239,479678,650646,250069,483958,907236,288642,596013,268683,185457,234779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]