SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419301 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419301 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262768,368069,192821,889821,58286,478153,190479,40773,837043,1028605,899454,282601,987445,812626,291284,752430,45198,958809,720749,899535,249582,1001243,212663,750459,303756,712358,491244,470859,805506,566523,842629,884520,891566,402790,181119,799554,545794,115524,265831,361687,952569,987036,724242,519942,305180,903320,196785,870774,930231,961827,740401,988132,1019585,523327,616304,492107,164812,332774,542722,933051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]