SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109018 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109018 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407170,374453,198511,388484,160121,1039875,255041,897670,920624,44872,950629,314644,579797,421812,607501,855613,103547,671577,222570,496279,582371,747055,457156,762923,740861,179374,770972,197363,504995,838647,391238,889542,147630,527705,428303,310234,196419,442956,272044,305489,218391,716581,892192,673916,58790,837292,227594,523724,875645,602547,537650,39954,647033,85347,878024,793636,773035,813001,670069,835121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002487s ]