SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102663 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102663 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150489,969485,1021942,915348,626219,661643,642712,185409,925416,679454,735733,636879,1032135,764776,723793,997775,223568,326138,110887,32417,933921,842366,489778,45027,1021676,906423,546763,1000600,272960,356611,519623,814771,153042,1034503,798836,416440,902305,175043,991842,682527,443089,604894,577926,423787,865051,148421,126837,151058,157309,671973,64264,18254,1048868,891846,150738,999617,61664,715312,751630,1024523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]