SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422442 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422442 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742453,1046318,35984,774353,164754,810198,709514,117492,894778,278282,168252,224089,761754,37229,391210,156050,159238,131189,213676,957773,383387,732484,570918,905149,193912,297290,710054,630404,142972,971765,37526,147965,872497,281347,511631,341507,529815,359244,67722,788262,962137,438865,475323,869601,880239,329420,532099,190405,631099,169100,437434,1023085,804418,1030623,562664,48616,420528,296433,799007,397690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]