SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573102 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573102 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113213,390480,1046709,1035113,128075,19581,428362,642621,958678,277177,390402,54334,948783,481255,537541,145043,566564,410629,14928,465299,994165,806737,423785,175741,728834,234050,322101,306310,358595,596240,291467,1037646,136920,658407,489016,490305,367840,160445,772045,29289,746545,842925,1048456,741550,816515,128367,991667,65153,57132,57116,698821,1019986,242838,971628,1001291,634898,1001231,38906,1014023,2289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]