SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019519 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019519 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454694,129767,26275,365640,893108,14104,385621,80339,5685,401718,312513,70139,942396,81221,792643,180872,388756,511345,809004,207563,208882,78090,323887,468640,408480,903982,946354,153715,98341,272529,603783,997523,535496,538111,525079,992200,374047,595952,389322,817782,778681,464592,585987,487720,692767,111521,564844,915914,758053,26922,599880,977162,565752,947460,130466,317790,941145,442917,945368,151820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]