SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983281 LIMIT 1 [ RunTime:0.000944s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983281 [ RunTime:0.004749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478400,726403,145481,59268,199626,130426,248422,805994,1018919,792311,583432,243471,789610,376445,298117,137277,92601,748831,816385,397205,614135,361514,658182,285657,221888,838355,566552,596569,606435,792210,904084,225797,785484,214162,76085,728176,275840,1040736,339799,230330,499048,684489,354847,399824,947924,663637,996853,501351,858974,598318,53948,901835,89047,511261,628133,54638,830369,352400,1008046,250025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]