SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 624028 LIMIT 1 [ RunTime:0.000724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 624028 [ RunTime:0.003150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531577,292021,1039773,686538,201973,644642,581461,751736,633517,214496,887717,928751,545333,96434,922622,899467,861583,40596,850848,768812,392842,971155,666004,223578,425854,896715,45881,806048,827543,862827,852348,475063,204187,734081,757298,649848,143496,9065,160656,707952,1038703,709843,616768,682409,575654,885628,908393,74716,381688,12053,120631,1033963,71132,718681,593735,153714,870541,475383,1027032,173816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 624028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 624028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]