SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40251 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40251 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670385,486557,83183,443,944036,9250,346980,1020352,52396,1045156,119000,106543,536166,582152,607382,871615,465996,407136,686757,448526,266727,715448,504161,276776,785606,999290,535205,753811,546352,822087,1047104,314699,561678,120807,350934,86022,221157,985154,516751,260560,443328,43415,759780,312611,424297,521971,388416,418312,375940,697013,256536,40710,451612,453903,573791,920786,423333,944913,1033112,235851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]