SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510238 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510238 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350162,1028964,137123,935177,986190,97985,37126,61479,814480,1002780,311578,292512,836150,866262,854076,371689,692090,346102,789280,511106,67291,1043121,773022,820000,217032,1045608,359104,299289,249398,625265,544231,449272,963741,35775,538581,501729,367111,609795,6733,52527,91040,641329,39072,345763,435239,265139,537380,493048,259051,1045692,898221,99540,484904,455483,19659,965441,4750,763657,356377,353194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003638s ]