SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027461 LIMIT 1 [ RunTime:0.001659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027461 [ RunTime:0.003780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508452,101499,591942,355250,847489,955301,211041,639520,216155,733391,722852,378149,300181,531210,787922,941848,910299,518868,371736,1041912,368934,942808,571888,642698,1018057,464613,1768,437816,826396,465581,393017,491297,730792,94730,910455,1023355,685532,754982,552848,21630,191437,563811,714224,320698,287854,538941,262874,615389,485172,42646,367824,404815,580984,127781,340741,100471,142184,865658,1017184,310111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]