SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20311 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20311 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354590,266283,261813,1043459,178813,90658,1040099,166217,547323,956141,668433,636222,285802,29677,762800,713722,14454,795310,853196,462883,1039626,10465,828208,591112,882708,67896,28792,799709,689878,941535,387766,614186,346268,32817,738925,523837,419452,684374,381982,1044112,259088,664689,410694,866884,642495,494076,995746,163763,228923,534104,689492,498987,854157,37520,274090,289826,815133,245508,710525,168663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]