SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501627 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501627 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588045,98053,268131,655949,263348,194266,744142,754963,1024914,411080,748154,833558,249422,448054,437848,927982,938466,950544,113091,171353,770309,416970,607947,141620,910949,724782,316520,710830,230501,971843,73666,957633,253289,864489,81960,1013270,26205,671406,582864,396678,210520,574638,261633,470201,800552,111576,60361,522055,986620,469084,763137,305569,139827,171376,24698,672894,202849,521920,432156,148331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]