SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562251 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562251 [ RunTime:0.001333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145150,1039602,231172,259750,463736,135869,80503,307146,316907,569699,620780,689244,866789,112619,112308,2587,598317,440599,622157,632703,1027690,659971,136860,481253,24604,593466,566303,472092,160848,911043,571519,929489,793913,110808,1002126,620153,872641,855173,584763,688224,27958,353423,694393,515660,296152,193252,481651,711714,47329,233842,105038,711623,548654,487684,599624,384816,641498,84415,32100,445769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]