SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019481 LIMIT 1 [ RunTime:0.000661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019481 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175450,809669,202107,512822,542017,621805,213059,810945,76725,256574,196845,131559,864894,717293,684417,830689,672084,602755,618390,648824,787377,954940,674062,150609,717714,699537,263174,745522,223686,412017,726645,75218,738033,170805,576551,661579,323545,493105,597474,657250,410127,967868,1046162,759651,747391,180157,196872,247665,516958,648669,938475,138649,403232,433270,1008547,164063,825807,273790,75201,639685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]