SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029398 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029398 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255084,889195,263396,287277,85019,551938,449532,22781,335831,610448,206566,825267,319740,814627,498087,446966,948758,154438,461191,754268,167640,632617,643314,892662,1004490,967715,538820,61513,854796,722649,186761,632014,545127,105602,281275,682474,948411,147746,289936,347727,581439,915182,169755,992,935922,73745,395518,238202,438018,924262,866811,487236,475211,828970,916337,308383,340909,366851,196411,932735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]