SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454215 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454215 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036042,468393,516694,789605,115790,200341,668246,580875,42445,530341,282759,5965,649972,817764,1013769,383586,168392,997678,548551,157945,940208,448808,341887,645294,858980,301514,762810,71977,45967,424796,382633,96783,631670,886541,432680,171438,340008,434024,776813,59509,753393,138915,58317,38044,49392,116802,512932,936245,251729,451078,908763,759050,637088,213654,110112,443310,31001,965875,975986,436547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]