SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490913 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490913 [ RunTime:0.003916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225955,509817,993195,1015790,28031,820987,408689,146292,649094,970240,799813,320636,564026,519029,374422,562936,350539,28704,492143,940618,1013949,661475,683391,797045,402998,415434,973770,839672,715560,303366,507394,41055,622901,825167,984228,287940,77243,841330,64863,785833,88104,463266,698222,541368,538350,504255,718363,275451,199340,476563,833867,154478,766403,841734,816485,498594,435547,875440,135983,1046422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]