SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199598 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199598 [ RunTime:0.003123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242898,1009049,824248,16652,320961,189631,1332,934576,805632,685626,1019651,409617,786452,1027835,229404,290209,979724,437783,292214,800895,281884,612688,217387,732699,388727,487731,957784,949573,586725,618089,504896,775608,932903,786922,930338,484973,434686,168494,1029120,457632,620151,1006070,247611,979187,193044,274941,37418,811232,416241,608358,312048,164614,340025,387063,979909,408053,902626,852393,200906,983883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]