SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474917 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474917 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881710,674896,984730,763588,41773,395267,399849,1048103,611069,881549,220010,872955,643244,252439,950116,811723,679783,845255,962162,310509,669118,751521,721861,160182,752154,263905,620860,452437,435665,974092,984664,144478,347561,780473,690191,163195,632380,303999,172280,284440,649068,229931,771595,208255,249254,773782,528853,804303,209697,900492,292379,199611,351758,441086,43163,673666,964668,24308,464613,229281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]