SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158911 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158911 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349681,18815,168353,945790,963802,667104,255923,266591,957514,57938,690130,268655,326178,24632,588589,529107,739842,412780,855136,351079,534336,527787,944368,71065,208868,647089,748160,1041582,490728,732764,77074,668979,114071,971984,627438,63516,821647,65137,948073,1045128,403484,539230,362067,232632,723513,996299,513455,397586,838377,794937,837370,685609,218370,787428,286419,262335,509373,985908,223293,404705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001615s ]