SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209814 LIMIT 1 [ RunTime:0.001219s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209814 [ RunTime:0.003738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159706,195241,578465,371424,602869,118264,622848,773478,205396,531267,248919,179430,608526,883199,426958,1001940,169991,333194,317812,1008023,30173,766205,157800,374295,493239,556444,637693,264544,861038,898043,990769,823212,476087,912977,204059,572674,713826,352323,49588,1016423,916592,357803,927244,185774,742442,951477,960904,867940,991073,920,869233,697543,1026918,699401,432882,480216,1023296,78773,778474,344710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]