SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42578 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42578 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410067,212831,175164,8369,881408,478164,878888,625,465968,997986,61688,230767,114235,68884,422788,774517,576942,677661,824485,299886,959816,132782,218197,896586,252799,976868,135170,785938,974761,178603,953949,150833,549826,603354,385479,573357,110294,279344,1042276,739762,709793,862732,591081,303527,457723,771374,1041194,244179,173701,949726,957890,316774,779679,347470,6362,695832,282346,239480,812840,352982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]