SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 629628 LIMIT 1 [ RunTime:0.000844s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 629628 [ RunTime:0.004708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511823,809044,787691,1017560,747803,174417,81975,84487,95817,260410,712000,83935,50556,125159,293285,296780,684243,451011,93617,978599,403989,957532,159532,56781,931731,338458,1007566,392532,621439,164418,200813,722897,155054,220751,182643,873379,956028,924526,632987,1002945,21002,119811,947684,188884,81874,225748,486343,562492,241128,953121,745060,297444,327125,579081,344659,950105,550867,848342,591925,575238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 629628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 629628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]