SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557716 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557716 [ RunTime:0.002443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013828,253675,578164,583449,1044932,520523,521923,265355,118110,619180,962493,751941,447740,614441,303449,849934,281360,721116,853105,616561,38388,355250,1006948,644268,538979,841650,854208,848846,916392,127992,3536,528618,191296,433781,116215,511359,9608,394378,836431,281135,902920,263088,746241,519196,141261,451781,34866,196774,204490,422565,663720,1025244,889969,785181,543076,230236,305570,245925,563264,1004928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]