SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539528 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539528 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360154,902992,167236,925929,93598,176600,496979,1039851,783780,761347,460775,130657,796874,848708,161971,892797,865049,582463,922508,143001,1045951,312760,731328,130790,865323,812934,91795,915177,281340,507009,993817,896401,1029173,360712,702435,35151,521480,713084,307347,465162,579840,350634,869104,680534,138695,966887,959816,344068,314723,938027,820434,889913,111320,394812,966815,1015320,184630,89045,560711,817046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]