SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544510 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544510 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744239,619348,749590,476054,290314,776200,227521,759368,826142,727136,695706,627382,380594,767946,664767,505500,893600,17853,119709,250140,923948,886822,665538,531159,891803,323252,400085,1029019,572374,84940,779228,762983,322657,955700,935103,104126,391264,859076,922611,427128,90878,826347,739009,952319,98466,476527,339649,553753,27987,601447,762853,992279,297495,947110,224348,138449,189507,1040616,4367,337104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]