SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542335 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542335 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850987,209721,408120,559626,219784,37550,408388,120246,374795,174508,683685,634234,693200,866942,69920,813602,74174,262402,613864,390287,528271,990126,750212,329439,495853,524296,414755,77526,272290,291773,284724,410352,1013891,355884,505160,114704,757438,523791,1029810,823266,11295,997992,728753,340190,139631,115828,1030131,982546,599778,156650,676996,556775,699596,757549,378809,31207,896582,663400,517081,884881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]