SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149813 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149813 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887337,1002720,813275,647785,406741,180147,683093,384391,645528,784908,162152,335240,752394,130712,238588,791403,71080,104949,369084,435739,599726,670146,535375,1025543,532310,182341,935944,977622,53381,461096,683446,880442,349047,912499,959916,262648,861934,44486,696355,855657,521315,159994,305533,776313,88602,128819,718637,313711,594062,475792,66741,977059,340033,765506,6455,251362,540962,107422,758142,684050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]