SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381540 LIMIT 1 [ RunTime:0.000826s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381540 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694346,193258,707975,516317,194858,434485,659927,233154,408090,584510,455244,670315,147523,413183,568968,624559,866609,841039,368537,1035989,1039697,179998,38102,113165,647361,795682,3323,583436,938158,398437,414443,404452,78985,619194,1007111,173748,534585,921667,939980,758796,705588,279611,300076,693559,520715,53918,249510,265920,304800,776741,12959,208541,477918,857118,167044,225597,1018882,408922,977123,47310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]