SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422438 LIMIT 1 [ RunTime:0.000891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422438 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003504,97728,591868,203627,165410,60986,664136,296538,263725,547499,294143,595390,384579,200219,1028858,819425,151856,424634,977341,307819,977859,424426,490755,784083,218912,143448,803832,425557,433859,10545,893019,804397,87841,218134,385406,287282,299307,1048073,588514,598577,682461,443111,1026752,783789,6220,259323,832309,262143,460278,497314,922102,919094,483531,188872,1353,926508,182544,72395,342188,289419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]