SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028679 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028679 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398833,798159,320122,1034231,615416,1011756,414798,845468,100028,678526,912914,554122,961551,959604,864231,760179,16747,112337,26005,111097,228526,480478,887625,309296,660939,766289,570599,40421,907957,716913,606329,604697,824153,263600,430274,311218,170810,412284,11179,320155,920287,705848,227336,403554,747665,114324,529164,578499,790719,466413,341120,1005979,416603,190424,703565,1012455,722027,690735,18938,798888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]