SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510091 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510091 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967108,362087,977801,871730,335276,926510,43809,330995,699314,897617,170763,828888,627615,183118,467228,641393,209522,554324,761935,76681,371865,528041,230716,648944,948563,789159,368236,417052,604085,1043380,114786,942084,391838,2504,412491,946510,764178,323202,655434,817519,276184,352688,891825,238624,244877,376383,404111,644723,804526,404767,696293,365589,902937,71033,678601,804609,760410,744680,353445,670922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]