SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036167 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036167 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442058,101194,103774,951890,22260,201366,904979,91381,105696,59106,836793,241478,284910,437973,56380,160368,726739,409668,867558,128187,832381,920759,597527,93305,1023043,60911,993569,688172,427995,779010,62200,58849,634245,535704,372337,575183,975909,355611,410115,924291,697539,182891,445653,462284,670621,170107,852202,235729,108688,620052,925864,474086,932850,973597,81638,500103,355451,531186,55628,853110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]