SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015612 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015612 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438055,645967,93987,253376,208137,883331,281794,781783,273740,170229,349857,311163,173594,322873,756003,682940,512693,991021,606238,349262,285901,29597,212458,955937,857266,723557,1020558,655332,181549,447844,268585,1037495,21325,697139,362005,459047,681425,598088,373888,452015,921942,224455,602160,386003,295942,645704,199086,1032517,689639,1037309,567675,43902,295677,22484,364365,207651,354938,304266,646446,1026474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]