SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585213 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585213 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237970,55425,472686,45637,281801,96349,241547,155835,348691,667191,541526,879178,460954,681774,530472,642023,346915,203021,377377,956836,4077,181983,360434,113337,663501,1025469,915550,606903,400897,292047,397990,788404,667700,52731,323989,78452,871670,329114,439808,804899,37505,870800,652285,873484,199582,283038,473123,411407,298719,325785,812941,930238,238356,209530,290391,532654,156978,1018442,763263,557925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]