SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006248 LIMIT 1 [ RunTime:0.000768s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006248 [ RunTime:0.001357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397496,11833,475571,79182,58452,310951,367516,898915,535425,612832,440482,842143,993294,1039656,177213,826506,124232,650182,685539,138239,986359,142465,241257,249215,656954,340704,260883,990097,889398,451480,327647,610489,1003427,337941,533433,736023,402812,1457,633473,446202,661646,292325,364116,185835,615969,417115,260488,891466,270524,727235,237622,109484,147428,582298,578297,360229,16183,189097,903335,253878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000964s ]