SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553802 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553802 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921137,949345,436588,312116,139971,363742,134061,836767,510282,196888,869556,371225,466169,82637,716967,404219,164820,669932,269426,334055,81394,346106,177519,465053,714111,639563,910116,335993,432905,753030,472860,171320,972995,941581,423916,725158,869657,1019670,1046862,678033,343274,191809,406904,424201,801404,455758,741567,478678,526684,742017,617007,559864,580182,70541,793274,967840,211347,589914,747058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]