SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 669954 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 669954 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227934,204869,169601,60099,408509,412896,629801,371210,295037,247645,534634,376612,647414,640281,874432,813743,605880,395615,920333,183800,117760,148568,650735,151672,754631,12967,749877,1029557,111309,57395,292620,103513,589786,265203,590702,202899,899567,851039,858307,715765,903398,497904,728963,73966,636154,1041393,844946,823760,738853,908264,363805,663372,156522,100566,45299,888928,418826,14574,48115,875424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 669954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 669954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]