SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471973 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471973 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471287,590344,743233,45588,1213,116558,794431,472933,347072,337203,454152,862954,639539,275698,195312,944752,798416,164903,367608,710915,631037,753345,389034,997560,303960,201982,633105,215931,443859,148268,826314,32615,928835,453036,248279,436755,885105,830698,378118,581076,243642,305265,71329,380250,648483,349672,121355,509338,621074,741738,814376,267065,43100,429801,369149,984371,959364,693649,133186,300382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]