SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159207 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159207 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151018,57367,345680,434766,449528,758364,256177,452782,802524,334041,769376,502840,271776,1001655,461475,842203,837508,282338,733638,415238,1032091,996596,843470,17904,948109,402476,774826,929927,69499,555484,898328,815634,232471,254841,295010,522574,100773,1022608,1033997,585331,538335,775415,206610,1029867,411890,846865,591331,719650,363187,959986,910010,732861,175279,635989,391284,456209,509469,485010,462796,357282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]