SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518134 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518134 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155089,525963,461769,629008,687243,996903,275274,1022185,47585,234282,114304,400932,457823,976281,133125,883531,393412,24788,836520,320760,92106,254397,256628,262601,76704,136678,617904,876481,168211,129501,273632,154827,633987,366965,429162,333673,44425,931006,626744,441380,144475,389112,864565,347509,31891,719417,709847,117172,714216,588512,636032,105142,218282,838462,744700,1048005,299631,150196,494170,754376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]