SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271063 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271063 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526715,1017389,194566,493041,625668,223529,943128,832556,548757,777027,954885,842305,508396,212462,736503,678800,782835,967147,411995,135287,672316,119766,809515,1004310,992193,1010145,550236,720747,836220,946376,301919,691499,55474,199732,357389,990116,275377,996377,837204,869496,461569,1024991,414254,729932,337335,386590,725621,1023181,775856,819574,293606,31249,1006828,33593,895749,345639,137403,474937,321836,607484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]