SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116439 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116439 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381498,1046876,269909,1040149,185769,543443,968041,889786,798071,319016,826370,934875,100536,760162,347701,348796,929492,157949,465782,696998,1015346,531967,738199,711002,776397,247768,607153,159457,605932,713674,434187,440903,700147,203240,427208,535030,10967,278201,12765,977190,636419,468314,290181,755056,73940,430951,1007485,749527,771108,992621,321284,830819,999578,923635,970304,489061,969393,672148,869085,434802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]