SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512087 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512087 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410379,366271,820159,879307,253862,543482,60050,568316,175536,735231,424366,94927,820730,196599,311656,234611,123583,550320,113615,515076,194551,978846,536707,957507,899105,531258,532508,960783,436668,878394,1040763,303675,118699,673977,1041553,65658,753047,137480,1005746,491184,285477,431280,415932,579569,467615,781891,506803,808190,778172,517293,787161,741482,663226,577352,3597,727159,149913,163642,202700,221709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]