SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021483 LIMIT 1 [ RunTime:0.001559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021483 [ RunTime:0.002887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608795,504751,38273,108785,533075,48727,734546,325979,487945,761568,809496,470736,242034,265858,584643,418196,364992,1023133,335582,631752,34212,1005855,747436,453509,56224,79588,609463,1007658,778371,330015,357863,65658,917884,78805,972414,486354,263396,671917,307457,57890,114735,683236,25350,411910,572171,271864,779126,181183,927567,802604,218678,755336,223880,173346,700735,887738,840232,187519,575052,777274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]