SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213509 LIMIT 1 [ RunTime:0.002301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213509 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48146,493381,844629,1017925,2519,79704,433279,746159,384789,704060,616187,834017,29665,10409,488120,931919,393031,722885,551930,516621,655808,509416,45994,552650,594756,978513,352539,111753,438854,808462,358748,342923,543173,469337,838771,429374,457163,940135,1033539,1032880,359271,460791,763016,379724,137740,547888,291047,584330,90936,180061,488555,469266,330846,894269,367836,813945,431439,27081,554840,609037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]