SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044034 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044034 [ RunTime:0.001368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901618,788261,475904,314306,503488,727691,661982,397034,818709,577835,50066,682705,844505,828729,557819,128597,254077,584727,706894,1035516,700961,686922,874724,515871,976152,414327,382718,956823,170595,154901,131796,476891,145869,402941,1023938,160389,712076,101603,491047,962263,765935,738013,49120,420430,485448,840959,187488,769458,803540,390239,381636,804334,315226,334835,729318,631055,1013634,833373,684371,592881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]