SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544971 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544971 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618265,856825,487477,821667,166913,254603,50588,107810,295833,217493,395144,346792,173669,562099,198791,167137,883405,1016802,260205,214617,957994,718709,356820,863378,1007175,162794,251761,5033,873563,282004,562327,154576,641097,365040,44000,670211,650096,251477,264586,937656,230299,398491,114557,574611,47490,931724,380842,690664,1022316,535384,475735,874323,176646,500954,922240,420288,642508,530495,1036906,984148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]