SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444191 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444191 [ RunTime:0.003207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472522,840162,723469,827406,121726,228359,888314,972991,493014,774249,444599,774363,75160,45427,150956,607922,444871,698340,153214,491160,820929,635737,641539,306400,150726,862153,142303,1002596,463629,291444,436342,1039252,318969,1039750,379212,660332,508567,145324,1035620,838208,947509,249379,165937,839893,244844,332441,304690,572169,864719,272288,1027,955249,806404,185587,714643,1029950,573094,414265,632356,1016296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]