SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386073 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386073 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447025,495711,206779,574864,60190,176289,531974,276835,430102,738818,835863,694267,943801,511116,8975,894315,320672,401117,429560,980915,595919,358245,263855,871778,435104,641702,773420,33265,1016463,215617,460863,865437,323718,736127,294844,510250,600810,670163,40887,263219,548724,297133,1013029,213836,483694,260948,385174,660781,1028795,181329,732899,767072,959577,317702,803353,893487,1001920,928873,642685,564174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]