SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485214 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485214 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250373,627812,179349,651267,100569,323341,520731,176375,822400,1044179,399724,438371,643235,82242,294747,229836,531331,794402,454075,571232,179897,196890,746229,569659,284917,843758,139084,218809,131321,988532,108253,869164,770799,797048,205409,929240,1005520,965649,632988,336948,930124,568320,262891,319190,79915,659052,189107,122179,22521,498089,490347,237430,686632,975797,590659,84757,222154,85223,508134,58607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]