SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392912 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392912 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494748,829843,966403,156330,340202,117301,845469,510429,220776,641006,400400,69815,700863,644165,399980,172084,422996,543413,906007,531323,79939,934277,347775,839629,598711,935638,156230,651216,993053,93890,477911,937561,505680,284067,1012029,31557,586443,91708,72585,814385,837306,67383,485078,429339,493118,559236,551219,168825,966601,865373,239292,276651,497964,243628,903449,257893,568516,143874,151948,393421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]