SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507538 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507538 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502742,422146,591139,659582,395672,933130,808925,651410,906789,598934,133068,74520,414776,679558,950647,147567,1122,978297,716354,213470,282383,13277,786995,506399,524556,653222,141965,272313,271592,147606,728076,11175,819962,824444,910306,573396,777092,1023849,605856,731340,964515,824835,800909,867979,1017726,381403,902547,517824,2041,129619,830264,141166,1038889,121866,136951,935613,695168,621020,934822,350998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]